/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : SQL Server
 Source Server Version : 12002000
 Source Host           : localhost:1433
 Source Catalog        : oa-prod
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 12002000
 File Encoding         : 65001

 Date: 12/06/2020 10:42:47
*/


-- ----------------------------
-- Table structure for project
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[project]') AND type IN ('U'))
	DROP TABLE [dbo].[project]
GO

CREATE TABLE [dbo].[project] (
  [id] int  IDENTITY(1000,1) NOT NULL,
  [name] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [address] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [build_unit] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [build_unit_user] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [supervision_unit] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [supervision_unit_user] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [construction_unit] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [construction_unit_user] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [structure_type] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [project_area] int  NULL,
  [project_const] int  NULL,
  [start_date] date  NULL,
  [delivery_date] date  NULL,
  [delivery_type] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [created_time] datetime DEFAULT (getdate()) NOT NULL,
  [last_modified_time] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[project] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'id',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目名称',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目地址',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'address'
GO

EXEC sp_addextendedproperty
'MS_Description', N'建设单位',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'build_unit'
GO

EXEC sp_addextendedproperty
'MS_Description', N'建设单位负责人',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'build_unit_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'监理单位',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'supervision_unit'
GO

EXEC sp_addextendedproperty
'MS_Description', N'监理单位负责人',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'supervision_unit_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'施工单位',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'construction_unit'
GO

EXEC sp_addextendedproperty
'MS_Description', N'施工单位负责人',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'construction_unit_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'结构形式',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'structure_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工程规模',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'project_area'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工程造价(万元)',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'project_const'
GO

EXEC sp_addextendedproperty
'MS_Description', N'开工日期',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'start_date'
GO

EXEC sp_addextendedproperty
'MS_Description', N'交付形式',
'SCHEMA', N'dbo',
'TABLE', N'project',
'COLUMN', N'delivery_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'抽样项目',
'SCHEMA', N'dbo',
'TABLE', N'project'
GO


-- ----------------------------
-- Records of [project]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[project] ON
GO

SET IDENTITY_INSERT [dbo].[project] OFF
GO


-- ----------------------------
-- Table structure for project_build
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[project_build]') AND type IN ('U'))
	DROP TABLE [dbo].[project_build]
GO

CREATE TABLE [dbo].[project_build] (
  [id] int  IDENTITY(100001,1) NOT NULL,
  [project_id] int  NOT NULL,
  [build] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [floor_num] int DEFAULT ((0)) NOT NULL,
  [family_num] int  NOT NULL,
  [standard_floor_num] int DEFAULT ((0)) NOT NULL,
  [pile_num] int DEFAULT ((0)) NULL,
  [beton_construction_floor_num] int  NULL,
  [remark1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [created_time] datetime DEFAULT (getdate()) NOT NULL,
  [last_modified_time] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[project_build] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'id',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目id',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'project_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'build'
GO

EXEC sp_addextendedproperty
'MS_Description', N'层数',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'floor_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'户数',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'family_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标准层',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'standard_floor_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'桩基个数',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'pile_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'混凝土-施工层数',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'beton_construction_floor_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'created_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后更新时间',
'SCHEMA', N'dbo',
'TABLE', N'project_build',
'COLUMN', N'last_modified_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目楼栋',
'SCHEMA', N'dbo',
'TABLE', N'project_build'
GO


-- ----------------------------
-- Records of [project_build]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[project_build] ON
GO


SET IDENTITY_INSERT [dbo].[project_build] OFF
GO


-- ----------------------------
-- Table structure for project_build_check
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[project_build_check]') AND type IN ('U'))
	DROP TABLE [dbo].[project_build_check]
GO

CREATE TABLE [dbo].[project_build_check] (
  [id] int  IDENTITY(1000001,1) NOT NULL,
  [project_build_id] int  NOT NULL,
  [project_check_id] int  NULL,
  [min] int DEFAULT ((0)) NOT NULL,
  [max] int DEFAULT ((0)) NOT NULL,
  [floor] int  NOT NULL,
  [remark2] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [created_time] datetime DEFAULT (getdate()) NOT NULL,
  [last_modified_time] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[project_build_check] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'id',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目楼栋id',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check',
'COLUMN', N'project_build_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'检查项id',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check',
'COLUMN', N'project_check_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最低',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check',
'COLUMN', N'min'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最高',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check',
'COLUMN', N'max'
GO

EXEC sp_addextendedproperty
'MS_Description', N'层',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check',
'COLUMN', N'floor'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check',
'COLUMN', N'created_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后更新时间',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check',
'COLUMN', N'last_modified_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目楼栋检查',
'SCHEMA', N'dbo',
'TABLE', N'project_build_check'
GO


-- ----------------------------
-- Records of [project_build_check]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[project_build_check] ON
GO

SET IDENTITY_INSERT [dbo].[project_build_check] OFF
GO


-- ----------------------------
-- Table structure for project_check
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[project_check]') AND type IN ('U'))
	DROP TABLE [dbo].[project_check]
GO

CREATE TABLE [dbo].[project_check] (
  [id] int  IDENTITY(1000,1) NOT NULL,
  [name] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [sort] int DEFAULT (datediff(second,'1970-01-01 00:00:00',getdate())) NOT NULL,
  [remark1] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [remark2] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [created_time] datetime DEFAULT (getdate()) NOT NULL,
  [last_modified_time] datetime DEFAULT (getdate()) NOT NULL
)
GO

ALTER TABLE [dbo].[project_check] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'id',
'SCHEMA', N'dbo',
'TABLE', N'project_check',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'project_check',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'project_check',
'COLUMN', N'sort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'project_check',
'COLUMN', N'created_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后修改时间',
'SCHEMA', N'dbo',
'TABLE', N'project_check',
'COLUMN', N'last_modified_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目-检查项',
'SCHEMA', N'dbo',
'TABLE', N'project_check'
GO


-- ----------------------------
-- Records of [project_check]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[project_check] ON
GO

INSERT INTO [dbo].[project_check] ([id], [name], [sort], [remark1], [remark2], [created_time], [last_modified_time]) VALUES (N'1001', N'混凝土结构-拆模工程', N'1', NULL, NULL, N'2020-05-01 10:54:44.887', N'2020-05-01 10:54:44.887')
GO

INSERT INTO [dbo].[project_check] ([id], [name], [sort], [remark1], [remark2], [created_time], [last_modified_time]) VALUES (N'1002', N'砌筑工程', N'2', NULL, NULL, N'2020-05-01 10:54:57.423', N'2020-05-01 10:54:57.423')
GO

INSERT INTO [dbo].[project_check] ([id], [name], [sort], [remark1], [remark2], [created_time], [last_modified_time]) VALUES (N'1003', N'建筑装饰-抹灰工程', N'3', NULL, NULL, N'2020-05-01 10:55:06.453', N'2020-05-01 10:55:06.453')
GO

INSERT INTO [dbo].[project_check] ([id], [name], [sort], [remark1], [remark2], [created_time], [last_modified_time]) VALUES (N'1004', N'建筑装饰-门窗工程', N'4', NULL, NULL, N'2020-05-01 10:55:15.770', N'2020-05-01 10:55:15.770')
GO

INSERT INTO [dbo].[project_check] ([id], [name], [sort], [remark1], [remark2], [created_time], [last_modified_time]) VALUES (N'1005', N'建筑装饰-防水工程', N'5', NULL, NULL, N'2020-05-01 10:55:23.893', N'2020-05-01 10:55:23.893')
GO

INSERT INTO [dbo].[project_check] ([id], [name], [sort], [remark1], [remark2], [created_time], [last_modified_time]) VALUES (N'1006', N'建筑装饰-幕墙工程', N'6', NULL, NULL, N'2020-05-01 10:55:36.897', N'2020-05-01 10:55:36.897')
GO

INSERT INTO [dbo].[project_check] ([id], [name], [sort], [remark1], [remark2], [created_time], [last_modified_time]) VALUES (N'1007', N'钢结构', N'7', NULL, NULL, N'2020-05-01 10:55:43.363', N'2020-05-01 10:55:43.363')
GO

SET IDENTITY_INSERT [dbo].[project_check] OFF
GO


-- ----------------------------
-- Table structure for project_sample
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[project_sample]') AND type IN ('U'))
	DROP TABLE [dbo].[project_sample]
GO

CREATE TABLE [dbo].[project_sample] (
  [id] int  IDENTITY(100001,1) NOT NULL,
  [project_id] int  NOT NULL,
  [name] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [type] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [remark1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [remark2] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [created_time] datetime DEFAULT (getdate()) NOT NULL,
  [last_modified_time] datetime DEFAULT (getdate()) NOT NULL,
  [state] nvarchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT ('NEW') NOT NULL
)
GO

ALTER TABLE [dbo].[project_sample] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'id',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目id',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'project_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'remark1'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注1',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'remark2'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'created_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后修改时间',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'last_modified_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态 NEW,CONFIRM',
'SCHEMA', N'dbo',
'TABLE', N'project_sample',
'COLUMN', N'state'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目抽样',
'SCHEMA', N'dbo',
'TABLE', N'project_sample'
GO


-- ----------------------------
-- Records of [project_sample]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[project_sample] ON
GO



SET IDENTITY_INSERT [dbo].[project_sample] OFF
GO


-- ----------------------------
-- Table structure for project_sample_item
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[project_sample_item]') AND type IN ('U'))
	DROP TABLE [dbo].[project_sample_item]
GO

CREATE TABLE [dbo].[project_sample_item] (
  [id] int  IDENTITY(1000001,1) NOT NULL,
  [project_sample_id] int  NOT NULL,
  [type] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [build] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [floor] int  NULL,
  [family] int  NULL,
  [remark1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [remark2] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [created_time] datetime DEFAULT (getdate()) NOT NULL,
  [last_modified_time] datetime DEFAULT (getdate()) NOT NULL,
  [check_id] int  NULL
)
GO

ALTER TABLE [dbo].[project_sample_item] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'id',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'抽样id',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'project_sample_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型 栋/层/户',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'栋',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'build'
GO

EXEC sp_addextendedproperty
'MS_Description', N'层',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'floor'
GO

EXEC sp_addextendedproperty
'MS_Description', N'户',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'family'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注1',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'remark1'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注2',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'remark2'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'created_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后更新时间',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'last_modified_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'检查项id',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item',
'COLUMN', N'check_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'项目抽样项',
'SCHEMA', N'dbo',
'TABLE', N'project_sample_item'
GO


-- ----------------------------
-- Records of [project_sample_item]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[project_sample_item] ON
GO


SET IDENTITY_INSERT [dbo].[project_sample_item] OFF
GO


-- ----------------------------
-- Uniques structure for table project
-- ----------------------------
ALTER TABLE [dbo].[project] ADD CONSTRAINT [UQ__project__72E12F1B091DCE3C] UNIQUE NONCLUSTERED ([name] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table project
-- ----------------------------
ALTER TABLE [dbo].[project] ADD CONSTRAINT [PK__project__3213E83F80337880] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Uniques structure for table project_build
-- ----------------------------
ALTER TABLE [dbo].[project_build] ADD CONSTRAINT [UQ__project___96051DA9DF4109F0] UNIQUE NONCLUSTERED ([project_id] ASC, [build] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table project_build
-- ----------------------------
ALTER TABLE [dbo].[project_build] ADD CONSTRAINT [PK__project___3213E83F7E01FA59] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Uniques structure for table project_build_check
-- ----------------------------
ALTER TABLE [dbo].[project_build_check] ADD CONSTRAINT [UQ__project___FC5E71F73CCBCE80] UNIQUE NONCLUSTERED ([project_build_id] ASC, [project_check_id] ASC, [floor] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table project_build_check
-- ----------------------------
ALTER TABLE [dbo].[project_build_check] ADD CONSTRAINT [PK__project___3213E83F3DD21D83] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Uniques structure for table project_check
-- ----------------------------
ALTER TABLE [dbo].[project_check] ADD CONSTRAINT [UQ__project___72E12F1B6624A923] UNIQUE NONCLUSTERED ([name] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table project_check
-- ----------------------------
ALTER TABLE [dbo].[project_check] ADD CONSTRAINT [PK__project___3213E83F6F67471B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table project_sample
-- ----------------------------
ALTER TABLE [dbo].[project_sample] ADD CONSTRAINT [PK__project___3213E83FCA997C6] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table project_sample_item
-- ----------------------------
ALTER TABLE [dbo].[project_sample_item] ADD CONSTRAINT [PK__project___3213E83FF50E3450] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

